import pandas as pd

df = pd.read_excel('./data.xlsx')
print(df.head())
result = []
for name , prov in zip(df['hosp_name'], df['province']):
    try:
        result.append(str(name)+'\u0001'+str(prov))
    except Exception as e:
        print(e)
        print(name, prov)
        quit()

with open('./keys.txt', 'a', encoding='utf-8') as f:
    for one in result:
        f.write(one.strip()+'\n')